﻿using System;

namespace edowork.com.Model
{
    #region warehouseInfo

    [Serializable]
    public class warehouseInfo
    {
        #region Private fields

        protected string _warehouseid = String.Empty;
        protected string _warehousename = String.Empty;
        protected string _clerk = String.Empty;
        protected string _telephone = String.Empty;
        protected string _sysdate = String.Empty;

        #endregion

        public warehouseInfo() { }

        #region Public Properties

        public string Warehouseid
        {
            get { return _warehouseid; }
            set { _warehouseid = value; }
        }

        public string Warehousename
        {
            get { return _warehousename; }
            set { _warehousename = value; }
        }

        public string Clerk
        {
            get { return _clerk; }
            set { _clerk = value; }
        }

        public string Telephone
        {
            get { return _telephone; }
            set { _telephone = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into warehouse(Warehouseid,Warehousename,Clerk,Telephone,Sysdate) values('{0}','{1}','{2}','{3}','{4}')";
        }

        #endregion

    }

    #endregion
}

